package com.last.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.last.entity.Area;
import com.last.entity.City;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

public interface CityTaskMapper extends BaseMapper<City> {

    @Select("SELECT * FROM city c LEFT JOIN district a ON a.city_id=c.city_id")
    public List<Map> selectCityIncludeArea();
}
